MySQL Lab Work Part 2 with Results

Insert Your Data

SQL Commands (4a–4m)

Drop & Create Database

Create Employee Table

Create Salary Table

Insert into Employee

Insert into Salary

Calculate Allowance

Calculate D_Allow

Calculate Gross

Calculate Tax

Calculate Net Salary

Display Salary Details

Display Directors, Managers, Officers

Display Net Salary by Department

Display Permanent Employees by Net Salary

Copied!